<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Location Tracking System</title>
<style> 
<!--
 /* Font Definitions */
@font-face
	{font-family:"Arial Black";
	panose-1:2 11 10 4 2 1 2 2 2 4;}
@font-face
	{font-family:"Times New Roman";
	panose-1:2 2 6 3 5 4 5 2 3 4;}
@font-face
	{font-family:Georgia;
	panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
	{font-family:Arial;
	panose-1:2 11 6 4 2 2 2 2 2 4;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin-right:0pt;
	text-indent:0pt;
	margin-top:0pt;
	margin-bottom:0pt;
	text-align:left;
	font-family:"Times New Roman";
	font-size:10.0pt;
	color:black;}
p.MsoOrganizationName, li.MsoOrganizationName, div.MsoOrganizationName
	{margin-right:0pt;
	text-indent:0pt;
	margin-top:0pt;
	margin-bottom:0pt;
	line-height:118%;
	text-align:left;
	font-family:"Arial Black";
	font-size:12.0pt;
	color:white;}
p.MsoTagline, li.MsoTagline, div.MsoTagline
	{margin-right:0pt;
	text-indent:0pt;
	margin-top:0pt;
	margin-bottom:0pt;
	line-height:118%;
	text-align:left;
	font-family:"Arial Black";
	font-size:8.0pt;
	color:black;}
p.MsoBodyText3, li.MsoBodyText3, div.MsoBodyText3
	{margin-right:0pt;
	text-indent:0pt;
	margin-top:0pt;
	margin-bottom:7.0pt;
	line-height:119%;
	text-align:left;
	font-family:Arial;
	font-size:9.0pt;
	color:black;}
p.MsoAccentText5, li.MsoAccentText5, div.MsoAccentText5, a
	{margin-right:0pt;
	text-indent:0pt;
	margin-top:0pt;
	margin-bottom:3.0pt;
	line-height:118%;
	text-align:left;
	font-family:Arial;
	font-size:9.0pt;
	color:black;
	font-weight:bold;}
ol
	{margin-top:0in;
	margin-bottom:0in;
	margin-left:-2197in;}
ul
	{margin-top:0in;
	margin-bottom:0in;
	margin-left:-2197in;}
@page
	{size:8.-2019in 11.2232in;}
-->
</style> 
</head>
<body bgcolor="#99CCFF" link="#0066FF" vlink="#6633CC" style='margin:0'>
    <table width="600" style="border: 1 px solid black;">
    	<tr>
    		<td>
    			<a href="?"><img src="http://group09.zxq.net/index_files/image1193.gif"></a>
    		</td>
    		<td>
    			<h1>&nbsp;&nbsp;Location Tracking System</h1>
    		</td>
    	</tr>
    	<tr>
    		<td width="20%" valign="top" align="left">
    			<a href="?">Users</a>
    		</td>
    		<td width="80%">
    		<?php 
    		$p = $_GET["p"];
    		if ($p == "data")
    			include("showData.php");
    		else{
    		?>
	    		<table width="100%"><tr><td>ID</td><td>Name</td><td>Surname</td><td>Access Code</td><td></td></tr>
	<?php
$mysql_host = "localhost";
$mysql_database = "group09_zxq_db";
$mysql_user = "326270_group09";
$mysql_password = "APMproject1";

$con = mysql_connect($mysql_host, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $con);

$sql = "select * from User order by user_ID asc";
$res = mysql_query($sql);
while($row = mysql_fetch_assoc($res)){
	?><tr><td><?=$row["user_ID"]?></td>
	<td><?=$row["first_Name"]?></td>
	<td><?=$row["last_Name"]?></td>
	<td><?=$row["accode"]?></td>
	<td><a href="?p=data&id=<?=$row["user_ID"]?>">See data</a></td>
	</tr><?}?>
	    		</table>
	    		<?php }?>
    		</td>
    	</tr>
    </table>
    </body>
</html>